pp108 : Bsfconfig for OLEDB

Bsfconfig for OLEDB

This topic contains the structure of the bsfconfig file used for OLEDB driver.


Using this code, create a bsfconfig file.

<configurations>
    <configuration
        htmfile="/cordys/cpc/bsf/developer/content/bsftabpage.htm" implementation="com.cordys.cpc.bsf.connector.BsfConnector">
        <component name="Rule Engine">
            <ruleAudit>false</ruleAudit>
            <publishAudit>false</publishAudit>
            <threadPoolSize>5</threadPoolSize>
            <maxDispatcherQueueSize>50000</maxDispatcherQueueSize>
        </component>
        <component name="Rule Repository ConnectionPool">
            <server>servername</server>
            <userName>userName</userName>
            <password>password in base64 encoded format</password>
            <defaultDatabase>databasename</defaultDatabase>
            <minimumReadConnections>1</minimumReadConnections>
            <maximumReadConnections>5</maximumReadConnections>
            <minimumWriteConnections>1</minimumWriteConnections>
            <maximumWriteConnections>5</maximumWriteConnections>
            <queryCacheSize>50</queryCacheSize>
            <queryCacheRefreshInterval>3600</queryCacheRefreshInterval>
            <cursorCacheSize>50</cursorCacheSize>
            <cursorCacheRefreshInterval>3600</cursorCacheRefreshInterval>
            <driverName>OLEDB</driverName>
            <provider>OLEDB provider name(like SQLNCLI)</provider>
            <vendor>SQL Server</vendor>
            <xmlEncoding>false</xmlEncoding>
            <multibyte>false</multibyte>
            <refreshInterval>3600</refreshInterval>
        </component>
        <ruleEnabled>true</ruleEnabled>
        <autoCleanup>false</autoCleanup>
        <auditEnabled>off</auditEnabled>
        <initializeDB>true</initializeDB>
        <initializeEIS>false</initializeEIS>
        <customInitializer>FQCN of class implementing IOnBsfConnector interface</customInitializer>
        <bsfuser>cn=demousr,cn=organizational users,o=system,cn=cordys,o=vanenburg.com</bsfuser>
        <component name="WS-AppServerConnectionPool">
            <server>servername</server>
            <userName>userName</userName>
            <password>password in base64 encoded format</password>
            <defaultDatabase>databasename</defaultDatabase>
            <operatingsystem>windows</operatingsystem>
            <maximumReadConnections>3</maximumReadConnections>
            <maximumWriteConnections>7</maximumWriteConnections>
            <queryCacheSize>50</queryCacheSize>
            <queryCacheRefreshInterval>3600</queryCacheRefreshInterval>
            <cursorCacheSize>50</cursorCacheSize>
            <cursorCacheRefreshInterval>3600</cursorCacheRefreshInterval>
            <driverName>OLEDB</driverName>
            <provider>OLEDB provider name(like SQLNCLI)</provider>
            <xmlEncoding>false</xmlEncoding>
            <multibyte>false</multibyte>
            <readEmptyStringAsNull>true</readEmptyStringAsNull>
            <writeEmptyStringAsNull>true</writeEmptyStringAsNull>
            <queryType>DBSQL</queryType>
            <auditInfo/>
        </component>
    </configuration>
</configurations>